select t1.navigation_id, t1.sister_navigation_id as t1_sister, t1.w_content_id, t1.template_id, t1.navigation_name, t1.path, t2.navigation_id as t2_id, t2.template_id as t2_template_id, t2.w_content_id as t2_content_id, t2.navigation_name as t2_name, t2.sister_navigation_id as t2_sister, t2.path as t2_path, t3.navigation_id as t3_id, t3.sister_navigation_id as t3_sister, t3.template_id as t3_template_id, t3.navigation_name as t3_name, t3.path as t3_path, t4.navigation_id as t4_id, t4.navigation_name as t4_name, t4.template_id as t4_template_id, t4.path as t4_path, t5.template_id as t5_template_id, t5.navigation_id as t5_id, t5.navigation_name as t5_name, t5.path as t5_path, t6.template_id as t6_template_id, t6.navigation_id as t6_id, t6.navigation_name as t6_name, t6.path as t6_path, t7.template_id as t7_template_id, t7.navigation_id as t7_id, t7.navigation_name as t7_name, t7.path as t7_path, t8.navigation_id as t8_id, t8.template_id as t8_template_id, t8.navigation_name as t8_name, t8.path as t8_path, t9.template_id as t9_template_id, t9.navigation_id as t9_id, t9.navigation_name as t9_name, t9.path as t9_path, t10.navigation_id as t10_id, t10.navigation_name as t10_name, t10.path as t10_path, t10.template_id as t10_template_id, t3.w_content_id as t3_content_id, t4.w_content_id as t4_content_id, t5.w_content_id as t5_content_id, t6.w_content_id as t6_content_id, t7.w_content_id as t7_content_id, t8.w_content_id as t8_content_id, t9.w_content_id as t9_content_id, t10.w_content_id as t10_content_id, t4.sister_navigation_id as t4_sister, t5.sister_navigation_id as t5_sister, t6.sister_navigation_id as t6_sister, t7.sister_navigation_id as t7_sister, t8.sister_navigation_id as t8_sister, t9.sister_navigation_id as t9_sister, t10.sister_navigation_id as t10_sister, t1.clickable as t1_click, t2.clickable as t2_click, t3.clickable as t3_click, t4.clickable as t4_click, t5.clickable as t5_click, t1.style_append as t1style, t2.style_append as t2style, t3.style_append as t3style, t4.style_append as t4style, t5.style_append as t5style, t1.section_title as t1sectit, t2.section_title as t2sectit, t3.section_title as t3sectit, t4.section_title as t4sectit, t5.section_title as t5sectit, t1.flyout as t1fly, t2.flyout as t2fly, t3.flyout as t3fly, t4.flyout as t4fly, t5.flyout as t5fly from lvh_navigation t1 left join lvh_navigation t2 on (t1.parent_navigation_id = t2.navigation_id) left join lvh_navigation t3 on (t2.parent_navigation_id = t3.navigation_id) left join lvh_navigation t4 on (t3.parent_navigation_id = t4.navigation_id) left join lvh_navigation t5 on (t4.parent_navigation_id = t5.navigation_id) left join lvh_navigation t6 on (t5.parent_navigation_id = t6.navigation_id) left join lvh_navigation t7 on (t6.parent_navigation_id = t7.navigation_id) left join lvh_navigation t8 on (t7.parent_navigation_id = t8.navigation_id) left join lvh_navigation t9 on (t8.parent_navigation_id = t9.navigation_id) left join lvh_navigation t10 on (t9.parent_navigation_id = t10.navigation_id) where t1.navigation_id = '7871'